﻿
//***********************************************************************
// * Module:   MsjJwbAqjsffgcZysjryHandler
// * 作者:  曹荣芝
// * Modified: 2013/5/30
// * Purpose: Definition of the Class MsjJwbAqjsffgcZysjryHandler 业务逻辑处理Handler类
// ***********************************************************************/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using XWG.Framework.MSException;
using XWG.Framework.AuthUtility;
using XWG.Framework.AuthEntity;
using XWG.Framework.AuthSPConst;
using XWG.Framework.AuthBLL;
using XWG.JWBST.JWBSTEntity;
using XWG.JWBST.JWBSTSPConst;
using System.Web.Script.Serialization;
using System.Data;
using XWG.Framework.Query;
using Newtonsoft.Json;
using Newtonsoft.Json.Converters;
using XWG.JWBST.JWBSTBLL;
namespace JWBSTAPP.AjaxServer
{
    /// <summary>
    /// MsjJwbAqjsffgcZysjryHandler 的摘要说明
    /// </summary>
    public class MsjJwbAqjsffgcZysjryHandler : JWBSTAPP.CommonClass.HttpHandlerBase,System.Web.SessionState.IRequiresSessionState
    {
      
        #region 添加记录
      /// <summary>
      /// 添加记录
      /// </summary>
      protected void AddRecord()
        {
             HttpContext context = HttpContext.Current;
            context.Response.ContentType = "text/plain";
            ResultModel mResultModel = new ResultModel(); //初始化返回类型
            try
            {
           
            MsjJwbAqjsffgcZysjry mMsjJwbAqjsffgcZysjry = new MsjJwbAqjsffgcZysjry();
            mMsjJwbAqjsffgcZysjry.Ryid = Guid.NewGuid().ToString(); //主键
                 mMsjJwbAqjsffgcZysjry.Gcid = context.Request.Form["texGcid"]; //工程ID
                 mMsjJwbAqjsffgcZysjry.Xm = context.Request.Form["texXm"]; //姓名
                 mMsjJwbAqjsffgcZysjry.Zw = context.Request.Form["texZw"]; //职务
                 mMsjJwbAqjsffgcZysjry.Jszc = context.Request.Form["texJszc"]; //技术职称
                 mMsjJwbAqjsffgcZysjry.Sfzh = context.Request.Form["texSfzh"]; //身份证号
                 mMsjJwbAqjsffgcZysjry.Pxm = Convert.ToDecimal(context.Request.Form["texPxm"]); //顺序码
                 mMsjJwbAqjsffgcZysjry.Cjsj = context.Request.Form["texCjsj"]; //创建时间(2013-05-28 09:13:01)
                 mMsjJwbAqjsffgcZysjry.Cjr = context.Request.Form["texCjr"]; //创建人(人员ID)
                 mMsjJwbAqjsffgcZysjry.Cjrdw = context.Request.Form["texCjrdw"]; //创建单位(单位ID)
                 mMsjJwbAqjsffgcZysjry.Xgr = context.Request.Form["texXgr"]; //修改人(人员ID)
                 mMsjJwbAqjsffgcZysjry.Xgrdw = context.Request.Form["texXgrdw"]; //修改人单位(单位ID)
                 mMsjJwbAqjsffgcZysjry.Xgsj = context.Request.Form["texXgsj"]; //修改时间(2013-05-28 09:13:01)
                 mMsjJwbAqjsffgcZysjry.Enabled = Enabled.TRUE; //是否有效（1有效，0无效）
                 mMsjJwbAqjsffgcZysjry.Movesign = context.Request.Form["texMovesign"]; //是否传输（1已，0未）
            
            mResultModel = MsjJwbAqjsffgcZysjryBLL.Insert(mMsjJwbAqjsffgcZysjry,context.Session["UserID"], true); //新建操作
            context.Response.Write(JsonConvert.SerializeObject(mResultModel)); //序列化后返回
            }
            catch (Exception ex)
            {
                MSEx.DealErr(ex, "");
                mResultModel.ErrorCode = -9999;
                mResultModel.ISSucceed = false;
                context.Response.Write(JsonConvert.SerializeObject(mResultModel)); //序列化后返回
            }
        }
        #endregion
        
        #region 删除记录
      /// <summary>
      /// 删除记录
      /// </summary>
       protected void DeleteRecord()
        {

            HttpContext context = HttpContext.Current;
            context.Response.ContentType = "text/plain";
            ResultModel mResultModel = new ResultModel(); //声明返回类型
            try
            {
			  string[] arryParamKey = context.Request.Params["id"].ToString().Split(',');
              if (arryParamKey.Length == 0)
                {
                    mResultModel.ErrorCode = -9991;
                    mResultModel.ISSucceed = false;
                    context.Response.Write(JsonConvert.SerializeObject(mResultModel)); //序列化后返回    
                    return ;
                }
                MsjJwbAqjsffgcZysjry mMsjJwbAqjsffgcZysjry = new MsjJwbAqjsffgcZysjry();                
				foreach (var paramKey in arryParamKey)
                {
                    mResultModel=MsjJwbAqjsffgcZysjryBLL.Delete(paramKey, context.Session["UserID"], true); //删除对应的信息
                }
				context.Response.Write(JsonConvert.SerializeObject(mResultModel)); ; //序列化后返回
            }
            catch (Exception ex)
            {
                MSEx.DealErr(ex, ""); //写入异常日志
                mResultModel.ErrorCode = -9999; //-9999代码是系统异常通用代码
                mResultModel.ISSucceed = false; //行为执行失败
                context.Response.Write(JsonConvert.SerializeObject(mResultModel)); //序列化后返回
            }
            
        } 
        #endregion
        
        #region 修改记录
      /// <summary>
      /// 修改记录
      /// </summary>
      protected void EditRecord()
        {
             HttpContext context = HttpContext.Current;
            context.Response.ContentType = "text/plain";
            ResultModel mResultModel = new ResultModel(); //初始化返回类型
           MsjJwbAqjsffgcZysjry mMsjJwbAqjsffgcZysjry = new MsjJwbAqjsffgcZysjry();

            string paramKey = context.Request.Params["id"];
            try
            {
                
                if(string.IsNullOrEmpty(paramKey))
                {
                    mResultModel.ErrorCode = -9991;
                    mResultModel.ISSucceed = false;
                    context.Response.Write(JsonConvert.SerializeObject(mResultModel)); //序列化后返回    
                    return ;
                }
                   mMsjJwbAqjsffgcZysjry = MsjJwbAqjsffgcZysjryBLL.Load(paramKey); //根据键值获取实体信息
                    if (mMsjJwbAqjsffgcZysjry != null)
                    {
                 mMsjJwbAqjsffgcZysjry.Gcid = context.Request.Form["texGcid"]; //工程ID
                 mMsjJwbAqjsffgcZysjry.Xm = context.Request.Form["texXm"]; //姓名
                 mMsjJwbAqjsffgcZysjry.Zw = context.Request.Form["texZw"]; //职务
                 mMsjJwbAqjsffgcZysjry.Jszc = context.Request.Form["texJszc"]; //技术职称
                 mMsjJwbAqjsffgcZysjry.Sfzh = context.Request.Form["texSfzh"]; //身份证号
                 mMsjJwbAqjsffgcZysjry.Pxm = Convert.ToDecimal(context.Request.Form["texPxm"]); //顺序码
                 mMsjJwbAqjsffgcZysjry.Cjsj = context.Request.Form["texCjsj"]; //创建时间(2013-05-28 09:13:01)
                 mMsjJwbAqjsffgcZysjry.Cjr = context.Request.Form["texCjr"]; //创建人(人员ID)
                 mMsjJwbAqjsffgcZysjry.Cjrdw = context.Request.Form["texCjrdw"]; //创建单位(单位ID)
                 mMsjJwbAqjsffgcZysjry.Xgr = context.Request.Form["texXgr"]; //修改人(人员ID)
                 mMsjJwbAqjsffgcZysjry.Xgrdw = context.Request.Form["texXgrdw"]; //修改人单位(单位ID)
                 mMsjJwbAqjsffgcZysjry.Xgsj = context.Request.Form["texXgsj"]; //修改时间(2013-05-28 09:13:01)
                 mMsjJwbAqjsffgcZysjry.Enabled = Enabled.TRUE; //是否有效（1有效，0无效）
                 mMsjJwbAqjsffgcZysjry.Movesign = context.Request.Form["texMovesign"]; //是否传输（1已，0未）
            
            mResultModel = MsjJwbAqjsffgcZysjryBLL.Update(mMsjJwbAqjsffgcZysjry,context.Session["UserID"], true); //新建操作
                 }
                else
                 {
                mResultModel.ErrorCode = -9990; //没有获取所需的信息，信息可能已被删除
                mResultModel.ISSucceed = false;
               
                 }
            context.Response.Write(JsonConvert.SerializeObject(mResultModel)); //序列化后返回
            }
            catch (Exception ex)
            {
                MSEx.DealErr(ex, "");
                mResultModel.ErrorCode = -9999;
                mResultModel.ISSucceed = false;
                context.Response.Write(JsonConvert.SerializeObject(mResultModel)); //序列化后返回
            }
        }    
        #endregion 
        
        #region 获取实体记录
      /// <summary>
      /// 获取实体记录
      /// </summary>
        protected void GetModel()
        {
            HttpContext context = HttpContext.Current;
            context.Response.ContentType = "text/plain";
             ResultModel mResultModel = new ResultModel(); //初始化返回类型
            string paramKey = context.Request.Params["id"];
            string json = "";
            try
            {
                MsjJwbAqjsffgcZysjry mMsjJwbAqjsffgcZysjry = new MsjJwbAqjsffgcZysjry(); //声明实体
                if (!string.IsNullOrEmpty(paramKey))
                {
                    mMsjJwbAqjsffgcZysjry = MsjJwbAqjsffgcZysjryBLL.Load(paramKey); //根据键值获取管理员
                    if (mMsjJwbAqjsffgcZysjry != null)
                    {
                        json = JsonConvert.SerializeObject(mMsjJwbAqjsffgcZysjry);
                    }
                }
            }
            catch (Exception ex)
            {
                MSEx.DealErr(ex, "");
                mResultModel.ErrorCode = -9990;
                mResultModel.ISSucceed = false;
                json = JsonConvert.SerializeObject(mResultModel);
            }
            context.Response.Write(json);
        }
        #endregion
        
        #region 获取数据
        /// <summary>
      /// 获取数据记录
      /// </summary>
       protected void QueryRecord()
        {
            TableMessage tm = new TableMessage();
            HearderMessage hm = new HearderMessage();
            List<HearderMessage> list = new List<HearderMessage>();
            HttpContext context = HttpContext.Current;
            context.Response.ContentType = "text/plain";
            string pageSize = context.Request.Form["pageSize"];
            string pageIndex = context.Request.Form["pageIndex"];
            if (String.IsNullOrEmpty(pageSize) || String.IsNullOrEmpty(pageIndex) || !AnyString.IsNumeric(pageSize) || !AnyString.IsNumeric(pageIndex))
                return;
            DataTable dtMsjJwbAqjsffgcZysjry = new DataTable();
            int intPageSize = Convert.ToInt32(pageSize);
            int intPageIndex = Convert.ToInt32(pageIndex);
            QueryByPage Q=new QueryByPage();
             QueryInfo qInfo=new QueryInfo();
             dtMsjJwbAqjsffgcZysjry = Q.GetRecordByPage("*", "", "", intPageSize, intPageIndex,  MsjJwbAqjsffgcZysjryConst.TableName, MsjJwbAqjsffgcZysjryConst.FieldKey, "").Tables[0];
             if (dtMsjJwbAqjsffgcZysjry != null && dtMsjJwbAqjsffgcZysjry.Rows.Count > 0)
             {
                 for (int i = 0; i < dtMsjJwbAqjsffgcZysjry.Columns.Count; i++)
                 {
                     hm = new HearderMessage();
                     hm.name = dtMsjJwbAqjsffgcZysjry.Columns[i].Caption;
                     list.Add(hm);
                 }
                 tm.Header = list;
                 tm.data = dtMsjJwbAqjsffgcZysjry;
                 tm.totalCount = Convert.ToString((int)Q.RowCount);
             }
            string json = JsonConvert.SerializeObject(tm);
            context.Response.Write(json);
        }
         #endregion   
        
}
}
 
 
